package light.head.dao.site;

import java.io.Serializable;

import light.head.framework.base.BaseDAO;
import light.head.model.SupplyAnnex;

import org.springframework.stereotype.Service;

@Service
public class SupplyAnnexDAO extends BaseDAO<SupplyAnnex, Serializable>{
	private static final String sql_getAnnex = "FROM SupplyAnnex sa WHERE sa.sic = ? AND sa.deleted = 0 AND sa.cover = 1";
	
	public SupplyAnnex getCover(Integer code){
		return (SupplyAnnex)super.get(sql_getAnnex, code);
	}
}
